Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 6611 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.0 MiB |
| Average record size in memory | 640.3 B |
Variable types
| Categorical | 12 |
|---|---|
| Numeric | 8 |
Source has constant value "AQS" | Constant |
POC has constant value "1" | Constant |
UNITS has constant value "ppm" | Constant |
AQS_PARAMETER_CODE has constant value "42101" | Constant |
AQS_PARAMETER_DESC has constant value "Carbon monoxide" | Constant |
STATE_CODE has constant value "36" | Constant |
STATE has constant value "New York" | Constant |
Date has a high cardinality: 731 distinct values | High cardinality |
Site ID is highly correlated with Daily Max 8-hour CO Concentration and 7 other fields | High correlation |
Daily Max 8-hour CO Concentration is highly correlated with Site ID and 7 other fields | High correlation |
DAILY_AQI_VALUE is highly correlated with Daily Max 8-hour CO Concentration | High correlation |
DAILY_OBS_COUNT is highly correlated with PERCENT_COMPLETE | High correlation |
PERCENT_COMPLETE is highly correlated with DAILY_OBS_COUNT | High correlation |
COUNTY_CODE is highly correlated with Site ID and 7 other fields | High correlation |
SITE_LATITUDE is highly correlated with Site ID and 7 other fields | High correlation |
SITE_LONGITUDE is highly correlated with Site ID and 6 other fields | High correlation |
Source is highly correlated with STATE and 9 other fields | High correlation |
POC is highly correlated with Source and 9 other fields | High correlation |
UNITS is highly correlated with Source and 9 other fields | High correlation |
Site Name is highly correlated with Site ID and 7 other fields | High correlation |
AQS_PARAMETER_CODE is highly correlated with Source and 9 other fields | High correlation |
AQS_PARAMETER_DESC is highly correlated with Source and 9 other fields | High correlation |
CBSA_CODE is highly correlated with Site ID and 7 other fields | High correlation |
CBSA_NAME is highly correlated with Site ID and 7 other fields | High correlation |
STATE_CODE is highly correlated with Source and 9 other fields | High correlation |
STATE is highly correlated with Source and 9 other fields | High correlation |
COUNTY is highly correlated with Site ID and 7 other fields | High correlation |
Date is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2024-05-07 19:17:58.282213 |
|---|---|
| Analysis finished | 2024-05-07 19:18:09.705849 |
| Duration | 11.42 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 731 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 432.7 KiB |
| 12/31/2021 | 10 |
|---|---|
| 08/05/2021 | 10 |
| 08/16/2021 | 10 |
| 08/15/2021 | 10 |
| 08/14/2021 | 10 |
| Other values (726) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 66110 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01/01/2020 |
|---|---|
| 2nd row | 01/02/2020 |
| 3rd row | 01/03/2020 |
| 4th row | 01/04/2020 |
| 5th row | 01/05/2020 |
Common Values
| Value | Count | Frequency (%) |
| 12/31/2021 | 10 | 0.2% |
| 08/05/2021 | 10 | 0.2% |
| 08/16/2021 | 10 | 0.2% |
| 08/15/2021 | 10 | 0.2% |
| 08/14/2021 | 10 | 0.2% |
| 08/13/2021 | 10 | 0.2% |
| 08/12/2021 | 10 | 0.2% |
| 08/11/2021 | 10 | 0.2% |
| 08/10/2021 | 10 | 0.2% |
| 08/09/2021 | 10 | 0.2% |
| Other values (721) | 6511 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 12/31/2021 | 10 | 0.2% |
| 12/11/2021 | 10 | 0.2% |
| 11/11/2021 | 10 | 0.2% |
| 12/04/2021 | 10 | 0.2% |
| 12/05/2021 | 10 | 0.2% |
| 12/06/2021 | 10 | 0.2% |
| 12/07/2021 | 10 | 0.2% |
| 12/30/2021 | 10 | 0.2% |
| 12/29/2021 | 10 | 0.2% |
| 12/28/2021 | 10 | 0.2% |
| Other values (721) | 6511 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 17815 | |
| 2 | 17115 | |
| / | 13222 | |
| 1 | 9182 | |
| 3 | 1544 | 2.3% |
| 8 | 1232 | 1.9% |
| 7 | 1220 | 1.8% |
| 5 | 1214 | 1.8% |
| 4 | 1200 | 1.8% |
| 9 | 1200 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 52888 | |
| Other Punctuation | 13222 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 17815 | |
| 2 | 17115 | |
| 1 | 9182 | |
| 3 | 1544 | 2.9% |
| 8 | 1232 | 2.3% |
| 7 | 1220 | 2.3% |
| 5 | 1214 | 2.3% |
| 4 | 1200 | 2.3% |
| 9 | 1200 | 2.3% |
| 6 | 1166 | 2.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 13222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 66110 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 17815 | |
| 2 | 17115 | |
| / | 13222 | |
| 1 | 9182 | |
| 3 | 1544 | 2.3% |
| 8 | 1232 | 1.9% |
| 7 | 1220 | 1.8% |
| 5 | 1214 | 1.8% |
| 4 | 1200 | 1.8% |
| 9 | 1200 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 66110 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 17815 | |
| 2 | 17115 | |
| / | 13222 | |
| 1 | 9182 | |
| 3 | 1544 | 2.3% |
| 8 | 1232 | 1.9% |
| 7 | 1220 | 1.8% |
| 5 | 1214 | 1.8% |
| 4 | 1200 | 1.8% |
| 9 | 1200 | 1.8% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 387.5 KiB |
| AQS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 19833 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AQS |
|---|---|
| 2nd row | AQS |
| 3rd row | AQS |
| 4th row | AQS |
| 5th row | AQS |
Common Values
| Value | Count | Frequency (%) |
| AQS | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| aqs | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 6611 | |
| Q | 6611 | |
| S | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 19833 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6611 | |
| Q | 6611 | |
| S | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19833 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 6611 | |
| Q | 6611 | |
| S | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19833 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 6611 | |
| Q | 6611 | |
| S | 6611 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 360571507.1 |
| Minimum | 360050133 |
|---|---|
| Maximum | 361030044 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 360050133 |
|---|---|
| 5-th percentile | 360050133 |
| Q1 | 360290023 |
| median | 360551007 |
| Q3 | 360810125 |
| 95-th percentile | 361010003 |
| Maximum | 361030044 |
| Range | 979911 |
| Interquartile range (IQR) | 520102 |
Descriptive statistics
| Standard deviation | 295431.0967 |
|---|---|
| Coefficient of variation (CV) | 0.0008193412148 |
| Kurtosis | -0.9307721959 |
| Mean | 360571507.1 |
| Median Absolute Deviation (MAD) | 259118 |
| Skewness | -0.1690481293 |
| Sum | 2.383738234 × 1012 |
| Variance | 8.727953289 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 360551007 | 727 | |
| 360610135 | 724 | |
| 360050133 | 721 | |
| 360810124 | 710 | |
| 360290023 | 709 | |
| 360550015 | 703 | |
| 361010003 | 702 | |
| 360810125 | 687 | |
| 360290005 | 661 | |
| 361030044 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| 360050133 | 721 | |
| 360290005 | 661 | |
| 360290023 | 709 | |
| 360550015 | 703 | |
| 360551007 | 727 | |
| 360610135 | 724 | |
| 360810124 | 710 | |
| 360810125 | 687 | |
| 361010003 | 702 | |
| 361030044 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| 361030044 | 267 | 4.0% |
| 361010003 | 702 | |
| 360810125 | 687 | |
| 360810124 | 710 | |
| 360610135 | 724 | |
| 360551007 | 727 | |
| 360550015 | 703 | |
| 360290023 | 709 | |
| 360290005 | 661 | |
| 360050133 | 721 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 374.6 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6611 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 1 | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6611 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6611 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6611 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 6611 |
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2988201482 |
| Minimum | 0 |
|---|---|
| Maximum | 1.9 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.2 |
| median | 0.3 |
| Q3 | 0.3 |
| 95-th percentile | 0.6 |
| Maximum | 1.9 |
| Range | 1.9 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.1573854059 |
|---|---|
| Coefficient of variation (CV) | 0.5266894043 |
| Kurtosis | 12.96018086 |
| Mean | 0.2988201482 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 2.594986045 |
| Sum | 1975.5 |
| Variance | 0.02477016598 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 0.2 | 2258 | |
| 0.3 | 2196 | |
| 0.4 | 897 | 13.6% |
| 0.1 | 548 | 8.3% |
| 0.5 | 345 | 5.2% |
| 0.6 | 149 | 2.3% |
| 0.7 | 75 | 1.1% |
| 0.8 | 52 | 0.8% |
| 0.9 | 34 | 0.5% |
| 1 | 20 | 0.3% |
| Other values (10) | 37 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 0.1 | 548 | 8.3% |
| 0.2 | 2258 | |
| 0.3 | 2196 | |
| 0.4 | 897 | 13.6% |
| 0.5 | 345 | 5.2% |
| 0.6 | 149 | 2.3% |
| 0.7 | 75 | 1.1% |
| 0.8 | 52 | 0.8% |
| 0.9 | 34 | 0.5% |
| Value | Count | Frequency (%) |
| 1.9 | 1 | < 0.1% |
| 1.8 | 2 | < 0.1% |
| 1.7 | 1 | < 0.1% |
| 1.6 | 2 | < 0.1% |
| 1.5 | 2 | < 0.1% |
| 1.4 | 3 | < 0.1% |
| 1.3 | 2 | < 0.1% |
| 1.2 | 5 | 0.1% |
| 1.1 | 17 | |
| 1 | 20 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 387.5 KiB |
| ppm |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 19833 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ppm |
|---|---|
| 2nd row | ppm |
| 3rd row | ppm |
| 4th row | ppm |
| 5th row | ppm |
Common Values
| Value | Count | Frequency (%) |
| ppm | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| ppm | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 13222 | |
| m | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 19833 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 13222 | |
| m | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19833 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 13222 | |
| m | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19833 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 13222 | |
| m | 6611 |
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.236726668 |
| Minimum | 0 |
|---|---|
| Maximum | 22 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 22 |
| Range | 22 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.944950511 |
|---|---|
| Coefficient of variation (CV) | 0.60090045 |
| Kurtosis | 9.35313006 |
| Mean | 3.236726668 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.277262232 |
| Sum | 21398 |
| Variance | 3.782832491 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 2 | 2258 | |
| 3 | 2196 | |
| 5 | 897 | 13.6% |
| 1 | 548 | 8.3% |
| 6 | 345 | 5.2% |
| 7 | 149 | 2.3% |
| 8 | 75 | 1.1% |
| 9 | 52 | 0.8% |
| 10 | 34 | 0.5% |
| 11 | 20 | 0.3% |
| Other values (10) | 37 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1 | 548 | 8.3% |
| 2 | 2258 | |
| 3 | 2196 | |
| 5 | 897 | 13.6% |
| 6 | 345 | 5.2% |
| 7 | 149 | 2.3% |
| 8 | 75 | 1.1% |
| 9 | 52 | 0.8% |
| 10 | 34 | 0.5% |
| Value | Count | Frequency (%) |
| 22 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 5 | 0.1% |
| 13 | 17 | |
| 11 | 20 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 461.2 KiB |
| ROCHESTER 2 | |
|---|---|
| CCNY | |
| PFIZER LAB SITE | |
| QUEENS COLLEGE 2 | |
| Buffalo Near-Road | |
| Other values (5) |
Length
| Max length | 24 |
|---|---|
| Median length | 16 |
| Mean length | 14.42051127 |
| Min length | 4 |
Characters and Unicode
| Total characters | 95334 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PFIZER LAB SITE |
|---|---|
| 2nd row | PFIZER LAB SITE |
| 3rd row | PFIZER LAB SITE |
| 4th row | PFIZER LAB SITE |
| 5th row | PFIZER LAB SITE |
Common Values
| Value | Count | Frequency (%) |
| ROCHESTER 2 | 727 | |
| CCNY | 724 | |
| PFIZER LAB SITE | 721 | |
| QUEENS COLLEGE 2 | 710 | |
| Buffalo Near-Road | 709 | |
| Rochester Near-Road | 703 | |
| PINNACLE STATE PARK | 702 | |
| Queens College Near Road | 687 | |
| BUFFALO | 661 | |
| Flax Pond | 267 | 4.0% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2 | 1437 | 9.4% |
| rochester | 1430 | 9.3% |
| near-road | 1412 | 9.2% |
| queens | 1397 | 9.1% |
| college | 1397 | 9.1% |
| buffalo | 1370 | 8.9% |
| ccny | 724 | 4.7% |
| site | 721 | 4.7% |
| lab | 721 | 4.7% |
| pfizer | 721 | 4.7% |
| Other values (7) | 4014 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8733 | 9.2% | |
| E | 7140 | 7.5% |
| e | 6253 | 6.6% |
| R | 5679 | 6.0% |
| a | 5174 | 5.4% |
| N | 4937 | 5.2% |
| o | 4465 | 4.7% |
| C | 4274 | 4.5% |
| L | 3504 | 3.7% |
| A | 3488 | 3.7% |
| Other values (28) | 41687 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 52121 | |
| Lowercase Letter | 31631 | |
| Space Separator | 8733 | 9.2% |
| Decimal Number | 1437 | 1.5% |
| Dash Punctuation | 1412 | 1.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 7140 | |
| R | 5679 | |
| N | 4937 | 9.5% |
| C | 4274 | 8.2% |
| L | 3504 | 6.7% |
| A | 3488 | 6.7% |
| S | 2860 | 5.5% |
| T | 2852 | 5.5% |
| P | 2392 | 4.6% |
| F | 2310 | 4.4% |
| Other values (10) | 12685 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 6253 | |
| a | 5174 | |
| o | 4465 | |
| r | 2802 | |
| d | 2366 | 7.5% |
| l | 2350 | 7.4% |
| f | 1418 | 4.5% |
| u | 1396 | 4.4% |
| s | 1390 | 4.4% |
| n | 954 | 3.0% |
| Other values (5) | 3063 |
Space Separator
| Value | Count | Frequency (%) |
| 8733 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1437 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1412 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83752 | |
| Common | 11582 | 12.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 7140 | 8.5% |
| e | 6253 | 7.5% |
| R | 5679 | 6.8% |
| a | 5174 | 6.2% |
| N | 4937 | 5.9% |
| o | 4465 | 5.3% |
| C | 4274 | 5.1% |
| L | 3504 | 4.2% |
| A | 3488 | 4.2% |
| S | 2860 | 3.4% |
| Other values (25) | 35978 |
Common
| Value | Count | Frequency (%) |
| 8733 | ||
| 2 | 1437 | 12.4% |
| - | 1412 | 12.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 95334 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8733 | 9.2% | |
| E | 7140 | 7.5% |
| e | 6253 | 6.6% |
| R | 5679 | 6.0% |
| a | 5174 | 5.4% |
| N | 4937 | 5.2% |
| o | 4465 | 4.7% |
| C | 4274 | 4.5% |
| L | 3504 | 3.7% |
| A | 3488 | 3.7% |
| Other values (28) | 41687 |
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.20450764 |
| Minimum | 1 |
|---|---|
| Maximum | 24 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 24 |
| median | 24 |
| Q3 | 24 |
| 95-th percentile | 24 |
| Maximum | 24 |
| Range | 23 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.788226427 |
|---|---|
| Coefficient of variation (CV) | 0.1201588273 |
| Kurtosis | 22.64665811 |
| Mean | 23.20450764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.407432971 |
| Sum | 153405 |
| Variance | 7.774206607 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 24 | 5968 | |
| 18 | 284 | 4.3% |
| 17 | 87 | 1.3% |
| 16 | 40 | 0.6% |
| 19 | 35 | 0.5% |
| 15 | 31 | 0.5% |
| 3 | 20 | 0.3% |
| 13 | 17 | 0.3% |
| 14 | 16 | 0.2% |
| 12 | 14 | 0.2% |
| Other values (14) | 99 | 1.5% |
| Value | Count | Frequency (%) |
| 1 | 4 | 0.1% |
| 2 | 4 | 0.1% |
| 3 | 20 | |
| 4 | 9 | |
| 5 | 4 | 0.1% |
| 6 | 9 | |
| 7 | 5 | 0.1% |
| 8 | 9 | |
| 9 | 6 | 0.1% |
| 10 | 10 |
| Value | Count | Frequency (%) |
| 24 | 5968 | |
| 23 | 9 | 0.1% |
| 22 | 4 | 0.1% |
| 21 | 13 | 0.2% |
| 20 | 5 | 0.1% |
| 19 | 35 | 0.5% |
| 18 | 284 | 4.3% |
| 17 | 87 | 1.3% |
| 16 | 40 | 0.6% |
| 15 | 31 | 0.5% |
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96.6933898 |
| Minimum | 4 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 75 |
| Q1 | 100 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 96 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.59098391 |
|---|---|
| Coefficient of variation (CV) | 0.1198735914 |
| Kurtosis | 22.65218537 |
| Mean | 96.6933898 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.407874457 |
| Sum | 639240 |
| Variance | 134.3509079 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 100 | 5968 | |
| 75 | 284 | 4.3% |
| 71 | 87 | 1.3% |
| 67 | 40 | 0.6% |
| 79 | 35 | 0.5% |
| 63 | 31 | 0.5% |
| 13 | 20 | 0.3% |
| 54 | 17 | 0.3% |
| 58 | 16 | 0.2% |
| 50 | 14 | 0.2% |
| Other values (14) | 99 | 1.5% |
| Value | Count | Frequency (%) |
| 4 | 4 | 0.1% |
| 8 | 4 | 0.1% |
| 13 | 20 | |
| 17 | 9 | |
| 21 | 4 | 0.1% |
| 25 | 9 | |
| 29 | 5 | 0.1% |
| 33 | 9 | |
| 38 | 6 | 0.1% |
| 42 | 10 |
| Value | Count | Frequency (%) |
| 100 | 5968 | |
| 96 | 9 | 0.1% |
| 92 | 4 | 0.1% |
| 88 | 13 | 0.2% |
| 83 | 5 | 0.1% |
| 79 | 35 | 0.5% |
| 75 | 284 | 4.3% |
| 71 | 87 | 1.3% |
| 67 | 40 | 0.6% |
| 63 | 31 | 0.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.4 KiB |
| 42101 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 33055 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 42101 |
|---|---|
| 2nd row | 42101 |
| 3rd row | 42101 |
| 4th row | 42101 |
| 5th row | 42101 |
Common Values
| Value | Count | Frequency (%) |
| 42101 | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 42101 | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 13222 | |
| 4 | 6611 | |
| 2 | 6611 | |
| 0 | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 33055 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 13222 | |
| 4 | 6611 | |
| 2 | 6611 | |
| 0 | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 33055 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 13222 | |
| 4 | 6611 | |
| 2 | 6611 | |
| 0 | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33055 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 13222 | |
| 4 | 6611 | |
| 2 | 6611 | |
| 0 | 6611 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 465.0 KiB |
| Carbon monoxide |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 99165 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Carbon monoxide |
|---|---|
| 2nd row | Carbon monoxide |
| 3rd row | Carbon monoxide |
| 4th row | Carbon monoxide |
| 5th row | Carbon monoxide |
Common Values
| Value | Count | Frequency (%) |
| Carbon monoxide | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| carbon | 6611 | |
| monoxide | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 19833 | |
| n | 13222 | |
| C | 6611 | 6.7% |
| a | 6611 | 6.7% |
| r | 6611 | 6.7% |
| b | 6611 | 6.7% |
| 6611 | 6.7% | |
| m | 6611 | 6.7% |
| x | 6611 | 6.7% |
| i | 6611 | 6.7% |
| Other values (2) | 13222 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 85943 | |
| Uppercase Letter | 6611 | 6.7% |
| Space Separator | 6611 | 6.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 19833 | |
| n | 13222 | |
| a | 6611 | 7.7% |
| r | 6611 | 7.7% |
| b | 6611 | 7.7% |
| m | 6611 | 7.7% |
| x | 6611 | 7.7% |
| i | 6611 | 7.7% |
| d | 6611 | 7.7% |
| e | 6611 | 7.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 6611 |
Space Separator
| Value | Count | Frequency (%) |
| 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 92554 | |
| Common | 6611 | 6.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 19833 | |
| n | 13222 | |
| C | 6611 | 7.1% |
| a | 6611 | 7.1% |
| r | 6611 | 7.1% |
| b | 6611 | 7.1% |
| m | 6611 | 7.1% |
| x | 6611 | 7.1% |
| i | 6611 | 7.1% |
| d | 6611 | 7.1% |
Common
| Value | Count | Frequency (%) |
| 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 99165 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 19833 | |
| n | 13222 | |
| C | 6611 | 6.7% |
| a | 6611 | 6.7% |
| r | 6611 | 6.7% |
| b | 6611 | 6.7% |
| 6611 | 6.7% | |
| m | 6611 | 6.7% |
| x | 6611 | 6.7% |
| i | 6611 | 6.7% |
| Other values (2) | 13222 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 400.4 KiB |
| 35620 | |
|---|---|
| 40380 | |
| 15380 | |
| 18500 |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 33055 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 35620 |
|---|---|
| 2nd row | 35620 |
| 3rd row | 35620 |
| 4th row | 35620 |
| 5th row | 35620 |
Common Values
| Value | Count | Frequency (%) |
| 35620 | 3109 | |
| 40380 | 1430 | |
| 15380 | 1370 | |
| 18500 | 702 | 10.6% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 35620 | 3109 | |
| 40380 | 1430 | |
| 15380 | 1370 | |
| 18500 | 702 | 10.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8743 | |
| 3 | 5909 | |
| 5 | 5181 | |
| 8 | 3502 | |
| 6 | 3109 | 9.4% |
| 2 | 3109 | 9.4% |
| 1 | 2072 | 6.3% |
| 4 | 1430 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 33055 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 8743 | |
| 3 | 5909 | |
| 5 | 5181 | |
| 8 | 3502 | |
| 6 | 3109 | 9.4% |
| 2 | 3109 | 9.4% |
| 1 | 2072 | 6.3% |
| 4 | 1430 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 33055 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 8743 | |
| 3 | 5909 | |
| 5 | 5181 | |
| 8 | 3502 | |
| 6 | 3109 | 9.4% |
| 2 | 3109 | 9.4% |
| 1 | 2072 | 6.3% |
| 4 | 1430 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33055 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 8743 | |
| 3 | 5909 | |
| 5 | 5181 | |
| 8 | 3502 | |
| 6 | 3109 | 9.4% |
| 2 | 3109 | 9.4% |
| 1 | 2072 | 6.3% |
| 4 | 1430 | 4.3% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 555.7 KiB |
| New York-Newark-Jersey City, NY-NJ-PA | |
|---|---|
| Rochester, NY | |
| Buffalo-Cheektowaga-Niagara Falls, NY | |
| Corning, NY |
Length
| Max length | 37 |
|---|---|
| Median length | 37 |
| Mean length | 29.04779912 |
| Min length | 11 |
Characters and Unicode
| Total characters | 192035 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York-Newark-Jersey City, NY-NJ-PA |
|---|---|
| 2nd row | New York-Newark-Jersey City, NY-NJ-PA |
| 3rd row | New York-Newark-Jersey City, NY-NJ-PA |
| 4th row | New York-Newark-Jersey City, NY-NJ-PA |
| 5th row | New York-Newark-Jersey City, NY-NJ-PA |
Common Values
| Value | Count | Frequency (%) |
| New York-Newark-Jersey City, NY-NJ-PA | 3109 | |
| Rochester, NY | 1430 | |
| Buffalo-Cheektowaga-Niagara Falls, NY | 1370 | |
| Corning, NY | 702 | 10.6% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| ny | 3502 | |
| new | 3109 | |
| york-newark-jersey | 3109 | |
| city | 3109 | |
| ny-nj-pa | 3109 | |
| rochester | 1430 | |
| buffalo-cheektowaga-niagara | 1370 | 6.6% |
| falls | 1370 | 6.6% |
| corning | 702 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 18036 | 9.4% |
| N | 17308 | 9.0% |
| - | 15176 | 7.9% |
| 14199 | 7.4% | |
| r | 12829 | 6.7% |
| a | 12699 | 6.6% |
| Y | 9720 | 5.1% |
| o | 7981 | 4.2% |
| w | 7588 | 4.0% |
| k | 7588 | 4.0% |
| Other values (19) | 68911 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 107234 | |
| Uppercase Letter | 48815 | |
| Dash Punctuation | 15176 | 7.9% |
| Space Separator | 14199 | 7.4% |
| Other Punctuation | 6611 | 3.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 18036 | |
| r | 12829 | |
| a | 12699 | |
| o | 7981 | |
| w | 7588 | |
| k | 7588 | |
| y | 6218 | 5.8% |
| t | 5909 | 5.5% |
| s | 5909 | 5.5% |
| i | 5181 | 4.8% |
| Other values (7) | 17296 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 17308 | |
| Y | 9720 | |
| J | 6218 | 12.7% |
| C | 5181 | 10.6% |
| P | 3109 | 6.4% |
| A | 3109 | 6.4% |
| R | 1430 | 2.9% |
| B | 1370 | 2.8% |
| F | 1370 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 15176 |
Space Separator
| Value | Count | Frequency (%) |
| 14199 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 156049 | |
| Common | 35986 | 18.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 18036 | 11.6% |
| N | 17308 | 11.1% |
| r | 12829 | 8.2% |
| a | 12699 | 8.1% |
| Y | 9720 | 6.2% |
| o | 7981 | 5.1% |
| w | 7588 | 4.9% |
| k | 7588 | 4.9% |
| J | 6218 | 4.0% |
| y | 6218 | 4.0% |
| Other values (16) | 49864 |
Common
| Value | Count | Frequency (%) |
| - | 15176 | |
| 14199 | ||
| , | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 192035 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 18036 | 9.4% |
| N | 17308 | 9.0% |
| - | 15176 | 7.9% |
| 14199 | 7.4% | |
| r | 12829 | 6.7% |
| a | 12699 | 6.6% |
| Y | 9720 | 5.1% |
| o | 7981 | 4.2% |
| w | 7588 | 4.0% |
| k | 7588 | 4.0% |
| Other values (19) | 68911 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 381.0 KiB |
| 36 |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 13222 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 36 |
|---|---|
| 2nd row | 36 |
| 3rd row | 36 |
| 4th row | 36 |
| 5th row | 36 |
Common Values
| Value | Count | Frequency (%) |
| 36 | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 36 | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 6611 | |
| 6 | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13222 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 6611 | |
| 6 | 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 13222 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 6611 | |
| 6 | 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13222 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 6611 | |
| 6 | 6611 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 419.8 KiB |
| New York |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 52888 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | New York |
| 5th row | New York |
Common Values
| Value | Count | Frequency (%) |
| New York | 6611 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| new | 6611 | |
| york | 6611 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 6611 | |
| e | 6611 | |
| w | 6611 | |
| 6611 | ||
| Y | 6611 | |
| o | 6611 | |
| r | 6611 | |
| k | 6611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 33055 | |
| Uppercase Letter | 13222 | 25.0% |
| Space Separator | 6611 | 12.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 6611 | |
| w | 6611 | |
| o | 6611 | |
| r | 6611 | |
| k | 6611 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 6611 | |
| Y | 6611 |
Space Separator
| Value | Count | Frequency (%) |
| 6611 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 46277 | |
| Common | 6611 | 12.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 6611 | |
| e | 6611 | |
| w | 6611 | |
| Y | 6611 | |
| o | 6611 | |
| r | 6611 | |
| k | 6611 |
Common
| Value | Count | Frequency (%) |
| 6611 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 6611 | |
| e | 6611 | |
| w | 6611 | |
| 6611 | ||
| Y | 6611 | |
| o | 6611 | |
| r | 6611 | |
| k | 6611 |
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.13341401 |
| Minimum | 5 |
|---|---|
| Maximum | 103 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 29 |
| median | 55 |
| Q3 | 81 |
| 95-th percentile | 101 |
| Maximum | 103 |
| Range | 98 |
| Interquartile range (IQR) | 52 |
Descriptive statistics
| Standard deviation | 29.54410618 |
|---|---|
| Coefficient of variation (CV) | 0.5171073127 |
| Kurtosis | -0.9306234125 |
| Mean | 57.13341401 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | -0.1679934489 |
| Sum | 377709 |
| Variance | 872.8542101 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 55 | 1430 | |
| 81 | 1397 | |
| 29 | 1370 | |
| 61 | 724 | |
| 5 | 721 | |
| 101 | 702 | |
| 103 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| 5 | 721 | |
| 29 | 1370 | |
| 55 | 1430 | |
| 61 | 724 | |
| 81 | 1397 | |
| 101 | 702 | |
| 103 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| 103 | 267 | 4.0% |
| 101 | 702 | |
| 81 | 1397 | |
| 61 | 724 | |
| 55 | 1430 | |
| 29 | 1370 | |
| 5 | 721 |
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 405.8 KiB |
| Monroe | |
|---|---|
| Queens | |
| Erie | |
| New York | |
| Bronx | |
| Other values (2) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 5.84208138 |
| Min length | 4 |
Characters and Unicode
| Total characters | 38622 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bronx |
|---|---|
| 2nd row | Bronx |
| 3rd row | Bronx |
| 4th row | Bronx |
| 5th row | Bronx |
Common Values
| Value | Count | Frequency (%) |
| Monroe | 1430 | |
| Queens | 1397 | |
| Erie | 1370 | |
| New York | 724 | |
| Bronx | 721 | |
| Steuben | 702 | |
| Suffolk | 267 | 4.0% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| monroe | 1430 | |
| queens | 1397 | |
| erie | 1370 | |
| new | 724 | |
| york | 724 | |
| bronx | 721 | |
| steuben | 702 | |
| suffolk | 267 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7722 | |
| o | 4572 | |
| n | 4250 | |
| r | 4245 | |
| u | 2366 | 6.1% |
| M | 1430 | 3.7% |
| Q | 1397 | 3.6% |
| s | 1397 | 3.6% |
| E | 1370 | 3.5% |
| i | 1370 | 3.5% |
| Other values (12) | 8503 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 30563 | |
| Uppercase Letter | 7335 | 19.0% |
| Space Separator | 724 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 7722 | |
| o | 4572 | |
| n | 4250 | |
| r | 4245 | |
| u | 2366 | 7.7% |
| s | 1397 | 4.6% |
| i | 1370 | 4.5% |
| k | 991 | 3.2% |
| w | 724 | 2.4% |
| x | 721 | 2.4% |
| Other values (4) | 2205 | 7.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 1430 | |
| Q | 1397 | |
| E | 1370 | |
| S | 969 | |
| Y | 724 | |
| N | 724 | |
| B | 721 |
Space Separator
| Value | Count | Frequency (%) |
| 724 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37898 | |
| Common | 724 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 7722 | |
| o | 4572 | |
| n | 4250 | |
| r | 4245 | |
| u | 2366 | 6.2% |
| M | 1430 | 3.8% |
| Q | 1397 | 3.7% |
| s | 1397 | 3.7% |
| E | 1370 | 3.6% |
| i | 1370 | 3.6% |
| Other values (11) | 7779 |
Common
| Value | Count | Frequency (%) |
| 724 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38622 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 7722 | |
| o | 4572 | |
| n | 4250 | |
| r | 4245 | |
| u | 2366 | 6.1% |
| M | 1430 | 3.7% |
| Q | 1397 | 3.6% |
| s | 1397 | 3.6% |
| E | 1370 | 3.5% |
| i | 1370 | 3.5% |
| Other values (12) | 8503 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.88254144 |
| Minimum | 40.73614 |
|---|---|
| Maximum | 43.14618 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | 40.73614 |
|---|---|
| 5-th percentile | 40.73614 |
| Q1 | 40.81976 |
| median | 42.09142 |
| Q3 | 42.92110728 |
| 95-th percentile | 43.14618 |
| Maximum | 43.14618 |
| Range | 2.41004 |
| Interquartile range (IQR) | 2.10134728 |
Descriptive statistics
| Standard deviation | 1.054355422 |
|---|---|
| Coefficient of variation (CV) | 0.02517410324 |
| Kurtosis | -1.850515277 |
| Mean | 41.88254144 |
| Median Absolute Deviation (MAD) | 1.05476 |
| Skewness | 0.05222111795 |
| Sum | 276885.4814 |
| Variance | 1.111665356 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 43.14618 | 727 | |
| 40.81976 | 724 | |
| 40.8679 | 721 | |
| 40.73614 | 710 | |
| 42.92110728 | 709 | |
| 43.14501268 | 703 | |
| 42.09142 | 702 | |
| 40.739264 | 687 | |
| 42.87690667 | 661 | |
| 40.961017 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| 40.73614 | 710 | |
| 40.739264 | 687 | |
| 40.81976 | 724 | |
| 40.8679 | 721 | |
| 40.961017 | 267 | 4.0% |
| 42.09142 | 702 | |
| 42.87690667 | 661 | |
| 42.92110728 | 709 | |
| 43.14501268 | 703 | |
| 43.14618 | 727 |
| Value | Count | Frequency (%) |
| 43.14618 | 727 | |
| 43.14501268 | 703 | |
| 42.92110728 | 709 | |
| 42.87690667 | 661 | |
| 42.09142 | 702 | |
| 40.961017 | 267 | 4.0% |
| 40.8679 | 721 | |
| 40.81976 | 724 | |
| 40.739264 | 687 | |
| 40.73614 | 710 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -76.00944233 |
| Minimum | -78.80952601 |
|---|---|
| Maximum | -73.139046 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 6611 |
| Negative (%) | 100.0% |
| Memory size | 51.8 KiB |
Quantile statistics
| Minimum | -78.80952601 |
|---|---|
| 5-th percentile | -78.80952601 |
| Q1 | -77.55728026 |
| median | -77.20978 |
| Q3 | -73.82153 |
| 95-th percentile | -73.817694 |
| Maximum | -73.139046 |
| Range | 5.670480012 |
| Interquartile range (IQR) | 3.73575026 |
Descriptive statistics
| Standard deviation | 2.138765962 |
|---|---|
| Coefficient of variation (CV) | -0.02813816147 |
| Kurtosis | -1.776028237 |
| Mean | -76.00944233 |
| Median Absolute Deviation (MAD) | 1.599746012 |
| Skewness | -0.02358159539 |
| Sum | -502498.4233 |
| Variance | 4.574319839 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| -77.54817 | 727 | |
| -73.94825 | 724 | |
| -73.87809 | 721 | |
| -73.82153 | 710 | |
| -78.76582533 | 709 | |
| -77.55728026 | 703 | |
| -77.20978 | 702 | |
| -73.817694 | 687 | |
| -78.80952601 | 661 | |
| -73.139046 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| -78.80952601 | 661 | |
| -78.76582533 | 709 | |
| -77.55728026 | 703 | |
| -77.54817 | 727 | |
| -77.20978 | 702 | |
| -73.94825 | 724 | |
| -73.87809 | 721 | |
| -73.82153 | 710 | |
| -73.817694 | 687 | |
| -73.139046 | 267 | 4.0% |
| Value | Count | Frequency (%) |
| -73.139046 | 267 | 4.0% |
| -73.817694 | 687 | |
| -73.82153 | 710 | |
| -73.87809 | 721 | |
| -73.94825 | 724 | |
| -77.20978 | 702 | |
| -77.54817 | 727 | |
| -77.55728026 | 703 | |
| -78.76582533 | 709 | |
| -78.80952601 | 661 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Date | Source | Site ID | POC | Daily Max 8-hour CO Concentration | UNITS | DAILY_AQI_VALUE | Site Name | DAILY_OBS_COUNT | PERCENT_COMPLETE | AQS_PARAMETER_CODE | AQS_PARAMETER_DESC | CBSA_CODE | CBSA_NAME | STATE_CODE | STATE | COUNTY_CODE | COUNTY | SITE_LATITUDE | SITE_LONGITUDE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 01/01/2020 | AQS | 360050133 | 1 | 0.2 | ppm | 2 | PFIZER LAB SITE | 19 | 79.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 1 | 01/02/2020 | AQS | 360050133 | 1 | 0.5 | ppm | 6 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 2 | 01/03/2020 | AQS | 360050133 | 1 | 0.6 | ppm | 7 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 3 | 01/04/2020 | AQS | 360050133 | 1 | 0.7 | ppm | 8 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 4 | 01/05/2020 | AQS | 360050133 | 1 | 0.3 | ppm | 3 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 5 | 01/06/2020 | AQS | 360050133 | 1 | 0.3 | ppm | 3 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 6 | 01/07/2020 | AQS | 360050133 | 1 | 0.4 | ppm | 5 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 7 | 01/08/2020 | AQS | 360050133 | 1 | 0.3 | ppm | 3 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 8 | 01/09/2020 | AQS | 360050133 | 1 | 0.3 | ppm | 3 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
| 9 | 01/10/2020 | AQS | 360050133 | 1 | 0.5 | ppm | 6 | PFIZER LAB SITE | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 5 | Bronx | 40.8679 | -73.87809 |
Last rows
| Date | Source | Site ID | POC | Daily Max 8-hour CO Concentration | UNITS | DAILY_AQI_VALUE | Site Name | DAILY_OBS_COUNT | PERCENT_COMPLETE | AQS_PARAMETER_CODE | AQS_PARAMETER_DESC | CBSA_CODE | CBSA_NAME | STATE_CODE | STATE | COUNTY_CODE | COUNTY | SITE_LATITUDE | SITE_LONGITUDE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6601 | 12/22/2021 | AQS | 361030044 | 1 | 0.3 | ppm | 3 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6602 | 12/23/2021 | AQS | 361030044 | 1 | 0.2 | ppm | 2 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6603 | 12/24/2021 | AQS | 361030044 | 1 | 0.2 | ppm | 2 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6604 | 12/25/2021 | AQS | 361030044 | 1 | 0.4 | ppm | 5 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6605 | 12/26/2021 | AQS | 361030044 | 1 | 0.4 | ppm | 5 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6606 | 12/27/2021 | AQS | 361030044 | 1 | 0.2 | ppm | 2 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6607 | 12/28/2021 | AQS | 361030044 | 1 | 0.2 | ppm | 2 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6608 | 12/29/2021 | AQS | 361030044 | 1 | 0.2 | ppm | 2 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6609 | 12/30/2021 | AQS | 361030044 | 1 | 0.3 | ppm | 3 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |
| 6610 | 12/31/2021 | AQS | 361030044 | 1 | 0.3 | ppm | 3 | Flax Pond | 24 | 100.0 | 42101 | Carbon monoxide | 35620 | New York-Newark-Jersey City, NY-NJ-PA | 36 | New York | 103 | Suffolk | 40.961017 | -73.139046 |